LOAD DATA
TRUNCATE 
INTO TABLE gex_bdu_gl_bal_tb
TRAILING NULLCOLS 
(line_no                SEQUENCE(MAX)
,date_eff		POSITION(1:11)		"TO_DATE(:date_eff,'YYYY/MM/DD')"                      
,entite			POSITION(12:26)		CHAR 
,div			POSITION(27:31) 	CHAR
,act			POSITION(32:36) 	CHAR    
,gest			POSITION(37:42)		CHAR
,cl 			POSITION(43:47) 	CHAR
,categ			POSITION(48:53)		CHAR
,geo			POSITION(54:58)		CHAR
,type			POSITION(59:63)		CHAR
,devise			POSITION(64:70)		CHAR
,poste			POSITION(71:77)		CHAR
,montant_local		POSITION(78:96)		"TO_NUMBER(:montant_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,montant_cad		POSITION(97:115)	"TO_NUMBER(:montant_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,provenance 		POSITION(116:126)	CHAR
)                                                                                                      
